Overview

SLAC policy requires Oracle passwords to be changed every six months. If they are not changed the account will become locked out and things will stop working. GLAST currently uses the following Oracle accounts:

To Do We should ask Karen to add more accounts here

Changing a password

To make the process of changing passwords simpler we use "Oracle Wallet" to store all of our passwords, so changing a password consists of two steps

1. Change the account password in oracle
2. Quickly update wallet to have the same password

Prerequisites:

• You will need to be able to log in to the glast account (more info) (on e.g. glastlnx07) or have write access to the wallet from your account
• You will need to know the oracle account you want to change the password for (oracleAccount)
• You will need to know the alias used for the oracle account you want to use (oracleAlias)
• You will need to know the old password for the account you want to change (oldPassword)
• You will need to decide on a new password (newPassword)
• You will need to know the oracle wallet password (in escrow as oraclewallet) (walletPassword)

A script exists to perform both steps of changing the password:

glast@glastlnx07 $ ~glast/oracle/bin/changeOraclePassword
(oracleAccount): glast_dp_test
(oracleAlias): pipeline-ii
(oldPassword):
(newPassword):
(walletPassword):

Note, after changing the oracle password your will have to notify developers of the new password so that they can use it in their personal settings for DBVis, Netbeans etc.

See Also

• GLAST oracle notes